﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsSystemLog" targetNamespace="http://tempuri.org/dsSystemLog.xsd" xmlns:mstns="http://tempuri.org/dsSystemLog.xsd" xmlns="http://tempuri.org/dsSystemLog.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblSystemLogTableAdapter" GeneratorDataComponentClassName="tblSystemLogTableAdapter" Name="tblSystemLog" UserDataComponentName="tblSystemLogTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblSystemLog" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblSystemLog] WHERE (([idLog] = @Original_idLog) AND ((@IsNull_cUsername = 1 AND [cUsername] IS NULL) OR ([cUsername] = @Original_cUsername)) AND ((@IsNull_cComputerName = 1 AND [cComputerName] IS NULL) OR ([cComputerName] = @Original_cComputerName)) AND ((@IsNull_cComputerAccount = 1 AND [cComputerAccount] IS NULL) OR ([cComputerAccount] = @Original_cComputerAccount)) AND ((@IsNull_dVisitDate = 1 AND [dVisitDate] IS NULL) OR ([dVisitDate] = @Original_dVisitDate)) AND ((@IsNull_cFunctionItem = 1 AND [cFunctionItem] IS NULL) OR ([cFunctionItem] = @Original_cFunctionItem)) AND ((@IsNull_cObjectName = 1 AND [cObjectName] IS NULL) OR ([cObjectName] = @Original_cObjectName)) AND ((@IsNull_cActionName = 1 AND [cActionName] IS NULL) OR ([cActionName] = @Original_cActionName)) AND ((@IsNull_cIPLAN = 1 AND [cIPLAN] IS NULL) OR ([cIPLAN] = @Original_cIPLAN)) AND ((@IsNull_cIPWAN = 1 AND [cIPWAN] IS NULL) OR ([cIPWAN] = @Original_cIPWAN)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idLog" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idLog" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cUsername" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUsername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cComputerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cComputerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cComputerAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cComputerAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dVisitDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dVisitDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFunctionItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFunctionItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cObjectName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cObjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cActionName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cActionName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIPLAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIPLAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIPWAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIPWAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblSystemLog] ([cUsername], [cComputerName], [cComputerAccount], [dVisitDate], [cFunctionItem], [cObjectName], [cActionName], [cIPLAN], [cIPWAN]) VALUES (@cUsername, @cComputerName, @cComputerAccount, @dVisitDate, @cFunctionItem, @cObjectName, @cActionName, @cIPLAN, @cIPWAN);
SELECT idLog, cUsername, cComputerName, cComputerAccount, dVisitDate, cFunctionItem, cObjectName, cActionName, cIPLAN, cIPWAN FROM tblSystemLog WHERE (idLog = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUsername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cComputerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cComputerAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dVisitDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFunctionItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cObjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cActionName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIPLAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIPWAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT idLog, cUsername, cComputerName, cComputerAccount, dVisitDate, cFunctionItem, cObjectName, cActionName, cIPLAN, cIPWAN FROM dbo.tblSystemLog</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblSystemLog] SET [cUsername] = @cUsername, [cComputerName] = @cComputerName, [cComputerAccount] = @cComputerAccount, [dVisitDate] = @dVisitDate, [cFunctionItem] = @cFunctionItem, [cObjectName] = @cObjectName, [cActionName] = @cActionName, [cIPLAN] = @cIPLAN, [cIPWAN] = @cIPWAN WHERE (([idLog] = @Original_idLog) AND ((@IsNull_cUsername = 1 AND [cUsername] IS NULL) OR ([cUsername] = @Original_cUsername)) AND ((@IsNull_cComputerName = 1 AND [cComputerName] IS NULL) OR ([cComputerName] = @Original_cComputerName)) AND ((@IsNull_cComputerAccount = 1 AND [cComputerAccount] IS NULL) OR ([cComputerAccount] = @Original_cComputerAccount)) AND ((@IsNull_dVisitDate = 1 AND [dVisitDate] IS NULL) OR ([dVisitDate] = @Original_dVisitDate)) AND ((@IsNull_cFunctionItem = 1 AND [cFunctionItem] IS NULL) OR ([cFunctionItem] = @Original_cFunctionItem)) AND ((@IsNull_cObjectName = 1 AND [cObjectName] IS NULL) OR ([cObjectName] = @Original_cObjectName)) AND ((@IsNull_cActionName = 1 AND [cActionName] IS NULL) OR ([cActionName] = @Original_cActionName)) AND ((@IsNull_cIPLAN = 1 AND [cIPLAN] IS NULL) OR ([cIPLAN] = @Original_cIPLAN)) AND ((@IsNull_cIPWAN = 1 AND [cIPWAN] IS NULL) OR ([cIPWAN] = @Original_cIPWAN)));
SELECT idLog, cUsername, cComputerName, cComputerAccount, dVisitDate, cFunctionItem, cObjectName, cActionName, cIPLAN, cIPWAN FROM tblSystemLog WHERE (idLog = @idLog)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cUsername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cComputerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cComputerAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dVisitDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFunctionItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cObjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cActionName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIPLAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIPWAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idLog" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idLog" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cUsername" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cUsername" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cUsername" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cComputerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cComputerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cComputerAccount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cComputerAccount" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cComputerAccount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dVisitDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dVisitDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dVisitDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFunctionItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFunctionItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFunctionItem" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cObjectName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cObjectName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cObjectName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cActionName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cActionName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cActionName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIPLAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIPLAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPLAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIPWAN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIPWAN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIPWAN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="idLog" ColumnName="idLog" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idLog" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idLog" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idLog" DataSetColumn="idLog" />
              <Mapping SourceColumn="cUsername" DataSetColumn="cUsername" />
              <Mapping SourceColumn="cComputerName" DataSetColumn="cComputerName" />
              <Mapping SourceColumn="cComputerAccount" DataSetColumn="cComputerAccount" />
              <Mapping SourceColumn="dVisitDate" DataSetColumn="dVisitDate" />
              <Mapping SourceColumn="cFunctionItem" DataSetColumn="cFunctionItem" />
              <Mapping SourceColumn="cObjectName" DataSetColumn="cObjectName" />
              <Mapping SourceColumn="cActionName" DataSetColumn="cActionName" />
              <Mapping SourceColumn="cIPLAN" DataSetColumn="cIPLAN" />
              <Mapping SourceColumn="cIPWAN" DataSetColumn="cIPWAN" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsSystemLog" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsSystemLog" msprop:Generator_UserDSName="dsSystemLog">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblSystemLog" msprop:Generator_TableClassName="tblSystemLogDataTable" msprop:Generator_TableVarName="tabletblSystemLog" msprop:Generator_TablePropName="tblSystemLog" msprop:Generator_RowDeletingName="tblSystemLogRowDeleting" msprop:Generator_UserTableName="tblSystemLog" msprop:Generator_RowChangingName="tblSystemLogRowChanging" msprop:Generator_RowEvHandlerName="tblSystemLogRowChangeEventHandler" msprop:Generator_RowDeletedName="tblSystemLogRowDeleted" msprop:Generator_RowEvArgName="tblSystemLogRowChangeEvent" msprop:Generator_RowChangedName="tblSystemLogRowChanged" msprop:Generator_RowClassName="tblSystemLogRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idLog" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidLog" msprop:Generator_ColumnPropNameInRow="idLog" msprop:Generator_ColumnPropNameInTable="idLogColumn" msprop:Generator_UserColumnName="idLog" type="xs:int" />
              <xs:element name="cUsername" msprop:Generator_ColumnVarNameInTable="columncUsername" msprop:Generator_ColumnPropNameInRow="cUsername" msprop:Generator_ColumnPropNameInTable="cUsernameColumn" msprop:Generator_UserColumnName="cUsername" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cComputerName" msprop:Generator_ColumnVarNameInTable="columncComputerName" msprop:Generator_ColumnPropNameInRow="cComputerName" msprop:Generator_ColumnPropNameInTable="cComputerNameColumn" msprop:Generator_UserColumnName="cComputerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cComputerAccount" msprop:Generator_ColumnVarNameInTable="columncComputerAccount" msprop:Generator_ColumnPropNameInRow="cComputerAccount" msprop:Generator_ColumnPropNameInTable="cComputerAccountColumn" msprop:Generator_UserColumnName="cComputerAccount" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dVisitDate" msprop:Generator_ColumnVarNameInTable="columndVisitDate" msprop:Generator_ColumnPropNameInRow="dVisitDate" msprop:Generator_ColumnPropNameInTable="dVisitDateColumn" msprop:Generator_UserColumnName="dVisitDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cFunctionItem" msprop:Generator_ColumnVarNameInTable="columncFunctionItem" msprop:Generator_ColumnPropNameInRow="cFunctionItem" msprop:Generator_ColumnPropNameInTable="cFunctionItemColumn" msprop:Generator_UserColumnName="cFunctionItem" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cObjectName" msprop:Generator_ColumnVarNameInTable="columncObjectName" msprop:Generator_ColumnPropNameInRow="cObjectName" msprop:Generator_ColumnPropNameInTable="cObjectNameColumn" msprop:Generator_UserColumnName="cObjectName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cActionName" msprop:Generator_ColumnVarNameInTable="columncActionName" msprop:Generator_ColumnPropNameInRow="cActionName" msprop:Generator_ColumnPropNameInTable="cActionNameColumn" msprop:Generator_UserColumnName="cActionName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cIPLAN" msprop:Generator_ColumnVarNameInTable="columncIPLAN" msprop:Generator_ColumnPropNameInRow="cIPLAN" msprop:Generator_ColumnPropNameInTable="cIPLANColumn" msprop:Generator_UserColumnName="cIPLAN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cIPWAN" msprop:Generator_ColumnVarNameInTable="columncIPWAN" msprop:Generator_ColumnPropNameInRow="cIPWAN" msprop:Generator_ColumnPropNameInTable="cIPWANColumn" msprop:Generator_UserColumnName="cIPWAN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblSystemLog" />
      <xs:field xpath="mstns:idLog" />
    </xs:unique>
  </xs:element>
</xs:schema>